Re: [GENERAL] Search - Mailing list pgsql-general

From Herouth Maoz
Subject Re: [GENERAL] Search
Date
Msg-id l03130303b3ca099402b4@[147.233.159.109]
Whole thread Raw
In response to Re: [GENERAL] Search  (Gilles Darold <darold@neptune.fr>)
List pgsql-general
At 03:43 +0300 on 01/08/1999, Gilles Darold wrote:


> I don't know about windows-1251. Perhaps this can't help you. But if
> you have japanese in you database, you can proceed a search on it so
> why not windows-1251 ?

Because the backend has to know that the lowercase for char NNN in this
codepage is MMM. This is different from one locale to the next. If it were
windows-1255 (Hebrew), there would be no lowercase at all for any character
above 224. So of course it's different than Japanese.

There can be two solutions to this problem:

1) Write a function using SPI, install it on the backend, and use
   it for the comparison.

2) Create the new locale, or at least the LC_CTYPE part of the locale,
   on the unix you are using.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma



pgsql-general by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] Large Object questions...
Next
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] Problem with a GROUP BY clause